package com.jcgyl.export.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class TbvieworderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TbvieworderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCTime(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Time(value.getTime()), property);
        }

        protected void addCriterionForJDBCTime(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Time> timeList = new ArrayList<java.sql.Time>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                timeList.add(new java.sql.Time(iter.next().getTime()));
            }
            addCriterion(condition, timeList, property);
        }

        protected void addCriterionForJDBCTime(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Time(value1.getTime()), new java.sql.Time(value2.getTime()), property);
        }

        public Criteria andExpressnumberIsNull() {
            addCriterion("expressnumber is null");
            return (Criteria) this;
        }

        public Criteria andExpressnumberIsNotNull() {
            addCriterion("expressnumber is not null");
            return (Criteria) this;
        }

        public Criteria andExpressnumberEqualTo(String value) {
            addCriterion("expressnumber =", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotEqualTo(String value) {
            addCriterion("expressnumber <>", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberGreaterThan(String value) {
            addCriterion("expressnumber >", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberGreaterThanOrEqualTo(String value) {
            addCriterion("expressnumber >=", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberLessThan(String value) {
            addCriterion("expressnumber <", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberLessThanOrEqualTo(String value) {
            addCriterion("expressnumber <=", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberLike(String value) {
            addCriterion("expressnumber like", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotLike(String value) {
            addCriterion("expressnumber not like", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberIn(List<String> values) {
            addCriterion("expressnumber in", values, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotIn(List<String> values) {
            addCriterion("expressnumber not in", values, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberBetween(String value1, String value2) {
            addCriterion("expressnumber between", value1, value2, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotBetween(String value1, String value2) {
            addCriterion("expressnumber not between", value1, value2, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andCbecodeIsNull() {
            addCriterion("cbecode is null");
            return (Criteria) this;
        }

        public Criteria andCbecodeIsNotNull() {
            addCriterion("cbecode is not null");
            return (Criteria) this;
        }

        public Criteria andCbecodeEqualTo(String value) {
            addCriterion("cbecode =", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotEqualTo(String value) {
            addCriterion("cbecode <>", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeGreaterThan(String value) {
            addCriterion("cbecode >", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeGreaterThanOrEqualTo(String value) {
            addCriterion("cbecode >=", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeLessThan(String value) {
            addCriterion("cbecode <", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeLessThanOrEqualTo(String value) {
            addCriterion("cbecode <=", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeLike(String value) {
            addCriterion("cbecode like", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotLike(String value) {
            addCriterion("cbecode not like", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeIn(List<String> values) {
            addCriterion("cbecode in", values, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotIn(List<String> values) {
            addCriterion("cbecode not in", values, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeBetween(String value1, String value2) {
            addCriterion("cbecode between", value1, value2, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotBetween(String value1, String value2) {
            addCriterion("cbecode not between", value1, value2, "cbecode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNull() {
            addCriterion("billmode is null");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNotNull() {
            addCriterion("billmode is not null");
            return (Criteria) this;
        }

        public Criteria andBillmodeEqualTo(String value) {
            addCriterion("billmode =", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotEqualTo(String value) {
            addCriterion("billmode <>", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThan(String value) {
            addCriterion("billmode >", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThanOrEqualTo(String value) {
            addCriterion("billmode >=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThan(String value) {
            addCriterion("billmode <", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThanOrEqualTo(String value) {
            addCriterion("billmode <=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLike(String value) {
            addCriterion("billmode like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotLike(String value) {
            addCriterion("billmode not like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIn(List<String> values) {
            addCriterion("billmode in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotIn(List<String> values) {
            addCriterion("billmode not in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeBetween(String value1, String value2) {
            addCriterion("billmode between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotBetween(String value1, String value2) {
            addCriterion("billmode not between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andCbenameIsNull() {
            addCriterion("cbename is null");
            return (Criteria) this;
        }

        public Criteria andCbenameIsNotNull() {
            addCriterion("cbename is not null");
            return (Criteria) this;
        }

        public Criteria andCbenameEqualTo(String value) {
            addCriterion("cbename =", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotEqualTo(String value) {
            addCriterion("cbename <>", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameGreaterThan(String value) {
            addCriterion("cbename >", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameGreaterThanOrEqualTo(String value) {
            addCriterion("cbename >=", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameLessThan(String value) {
            addCriterion("cbename <", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameLessThanOrEqualTo(String value) {
            addCriterion("cbename <=", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameLike(String value) {
            addCriterion("cbename like", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotLike(String value) {
            addCriterion("cbename not like", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameIn(List<String> values) {
            addCriterion("cbename in", values, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotIn(List<String> values) {
            addCriterion("cbename not in", values, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameBetween(String value1, String value2) {
            addCriterion("cbename between", value1, value2, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotBetween(String value1, String value2) {
            addCriterion("cbename not between", value1, value2, "cbename");
            return (Criteria) this;
        }

        public Criteria andEcpcodeIsNull() {
            addCriterion("ecpcode is null");
            return (Criteria) this;
        }

        public Criteria andEcpcodeIsNotNull() {
            addCriterion("ecpcode is not null");
            return (Criteria) this;
        }

        public Criteria andEcpcodeEqualTo(String value) {
            addCriterion("ecpcode =", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotEqualTo(String value) {
            addCriterion("ecpcode <>", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeGreaterThan(String value) {
            addCriterion("ecpcode >", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ecpcode >=", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeLessThan(String value) {
            addCriterion("ecpcode <", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeLessThanOrEqualTo(String value) {
            addCriterion("ecpcode <=", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeLike(String value) {
            addCriterion("ecpcode like", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotLike(String value) {
            addCriterion("ecpcode not like", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeIn(List<String> values) {
            addCriterion("ecpcode in", values, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotIn(List<String> values) {
            addCriterion("ecpcode not in", values, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeBetween(String value1, String value2) {
            addCriterion("ecpcode between", value1, value2, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotBetween(String value1, String value2) {
            addCriterion("ecpcode not between", value1, value2, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpnameIsNull() {
            addCriterion("ecpname is null");
            return (Criteria) this;
        }

        public Criteria andEcpnameIsNotNull() {
            addCriterion("ecpname is not null");
            return (Criteria) this;
        }

        public Criteria andEcpnameEqualTo(String value) {
            addCriterion("ecpname =", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotEqualTo(String value) {
            addCriterion("ecpname <>", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameGreaterThan(String value) {
            addCriterion("ecpname >", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameGreaterThanOrEqualTo(String value) {
            addCriterion("ecpname >=", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameLessThan(String value) {
            addCriterion("ecpname <", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameLessThanOrEqualTo(String value) {
            addCriterion("ecpname <=", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameLike(String value) {
            addCriterion("ecpname like", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotLike(String value) {
            addCriterion("ecpname not like", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameIn(List<String> values) {
            addCriterion("ecpname in", values, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotIn(List<String> values) {
            addCriterion("ecpname not in", values, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameBetween(String value1, String value2) {
            addCriterion("ecpname between", value1, value2, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotBetween(String value1, String value2) {
            addCriterion("ecpname not between", value1, value2, "ecpname");
            return (Criteria) this;
        }

        public Criteria andPurchasernameIsNull() {
            addCriterion("purchasername is null");
            return (Criteria) this;
        }

        public Criteria andPurchasernameIsNotNull() {
            addCriterion("purchasername is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasernameEqualTo(String value) {
            addCriterion("purchasername =", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameNotEqualTo(String value) {
            addCriterion("purchasername <>", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameGreaterThan(String value) {
            addCriterion("purchasername >", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameGreaterThanOrEqualTo(String value) {
            addCriterion("purchasername >=", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameLessThan(String value) {
            addCriterion("purchasername <", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameLessThanOrEqualTo(String value) {
            addCriterion("purchasername <=", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameLike(String value) {
            addCriterion("purchasername like", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameNotLike(String value) {
            addCriterion("purchasername not like", value, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameIn(List<String> values) {
            addCriterion("purchasername in", values, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameNotIn(List<String> values) {
            addCriterion("purchasername not in", values, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameBetween(String value1, String value2) {
            addCriterion("purchasername between", value1, value2, "purchasername");
            return (Criteria) this;
        }

        public Criteria andPurchasernameNotBetween(String value1, String value2) {
            addCriterion("purchasername not between", value1, value2, "purchasername");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoIsNull() {
            addCriterion("buyerregno is null");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoIsNotNull() {
            addCriterion("buyerregno is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoEqualTo(String value) {
            addCriterion("buyerregno =", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoNotEqualTo(String value) {
            addCriterion("buyerregno <>", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoGreaterThan(String value) {
            addCriterion("buyerregno >", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoGreaterThanOrEqualTo(String value) {
            addCriterion("buyerregno >=", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoLessThan(String value) {
            addCriterion("buyerregno <", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoLessThanOrEqualTo(String value) {
            addCriterion("buyerregno <=", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoLike(String value) {
            addCriterion("buyerregno like", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoNotLike(String value) {
            addCriterion("buyerregno not like", value, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoIn(List<String> values) {
            addCriterion("buyerregno in", values, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoNotIn(List<String> values) {
            addCriterion("buyerregno not in", values, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoBetween(String value1, String value2) {
            addCriterion("buyerregno between", value1, value2, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andBuyerregnoNotBetween(String value1, String value2) {
            addCriterion("buyerregno not between", value1, value2, "buyerregno");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneIsNull() {
            addCriterion("purchasertelephone is null");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneIsNotNull() {
            addCriterion("purchasertelephone is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneEqualTo(String value) {
            addCriterion("purchasertelephone =", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneNotEqualTo(String value) {
            addCriterion("purchasertelephone <>", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneGreaterThan(String value) {
            addCriterion("purchasertelephone >", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("purchasertelephone >=", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneLessThan(String value) {
            addCriterion("purchasertelephone <", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneLessThanOrEqualTo(String value) {
            addCriterion("purchasertelephone <=", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneLike(String value) {
            addCriterion("purchasertelephone like", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneNotLike(String value) {
            addCriterion("purchasertelephone not like", value, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneIn(List<String> values) {
            addCriterion("purchasertelephone in", values, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneNotIn(List<String> values) {
            addCriterion("purchasertelephone not in", values, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneBetween(String value1, String value2) {
            addCriterion("purchasertelephone between", value1, value2, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andPurchasertelephoneNotBetween(String value1, String value2) {
            addCriterion("purchasertelephone not between", value1, value2, "purchasertelephone");
            return (Criteria) this;
        }

        public Criteria andOrdersumIsNull() {
            addCriterion("ordersum is null");
            return (Criteria) this;
        }

        public Criteria andOrdersumIsNotNull() {
            addCriterion("ordersum is not null");
            return (Criteria) this;
        }

        public Criteria andOrdersumEqualTo(BigDecimal value) {
            addCriterion("ordersum =", value, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumNotEqualTo(BigDecimal value) {
            addCriterion("ordersum <>", value, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumGreaterThan(BigDecimal value) {
            addCriterion("ordersum >", value, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ordersum >=", value, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumLessThan(BigDecimal value) {
            addCriterion("ordersum <", value, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ordersum <=", value, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumIn(List<BigDecimal> values) {
            addCriterion("ordersum in", values, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumNotIn(List<BigDecimal> values) {
            addCriterion("ordersum not in", values, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ordersum between", value1, value2, "ordersum");
            return (Criteria) this;
        }

        public Criteria andOrdersumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ordersum not between", value1, value2, "ordersum");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueIsNull() {
            addCriterion("goodsvalue is null");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueIsNotNull() {
            addCriterion("goodsvalue is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueEqualTo(BigDecimal value) {
            addCriterion("goodsvalue =", value, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueNotEqualTo(BigDecimal value) {
            addCriterion("goodsvalue <>", value, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueGreaterThan(BigDecimal value) {
            addCriterion("goodsvalue >", value, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goodsvalue >=", value, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueLessThan(BigDecimal value) {
            addCriterion("goodsvalue <", value, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goodsvalue <=", value, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueIn(List<BigDecimal> values) {
            addCriterion("goodsvalue in", values, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueNotIn(List<BigDecimal> values) {
            addCriterion("goodsvalue not in", values, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goodsvalue between", value1, value2, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andGoodsvalueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goodsvalue not between", value1, value2, "goodsvalue");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxIsNull() {
            addCriterion("consumptiontax is null");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxIsNotNull() {
            addCriterion("consumptiontax is not null");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxEqualTo(BigDecimal value) {
            addCriterion("consumptiontax =", value, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxNotEqualTo(BigDecimal value) {
            addCriterion("consumptiontax <>", value, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxGreaterThan(BigDecimal value) {
            addCriterion("consumptiontax >", value, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("consumptiontax >=", value, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxLessThan(BigDecimal value) {
            addCriterion("consumptiontax <", value, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("consumptiontax <=", value, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxIn(List<BigDecimal> values) {
            addCriterion("consumptiontax in", values, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxNotIn(List<BigDecimal> values) {
            addCriterion("consumptiontax not in", values, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("consumptiontax between", value1, value2, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andConsumptiontaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("consumptiontax not between", value1, value2, "consumptiontax");
            return (Criteria) this;
        }

        public Criteria andVatIsNull() {
            addCriterion("vat is null");
            return (Criteria) this;
        }

        public Criteria andVatIsNotNull() {
            addCriterion("vat is not null");
            return (Criteria) this;
        }

        public Criteria andVatEqualTo(BigDecimal value) {
            addCriterion("vat =", value, "vat");
            return (Criteria) this;
        }

        public Criteria andVatNotEqualTo(BigDecimal value) {
            addCriterion("vat <>", value, "vat");
            return (Criteria) this;
        }

        public Criteria andVatGreaterThan(BigDecimal value) {
            addCriterion("vat >", value, "vat");
            return (Criteria) this;
        }

        public Criteria andVatGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("vat >=", value, "vat");
            return (Criteria) this;
        }

        public Criteria andVatLessThan(BigDecimal value) {
            addCriterion("vat <", value, "vat");
            return (Criteria) this;
        }

        public Criteria andVatLessThanOrEqualTo(BigDecimal value) {
            addCriterion("vat <=", value, "vat");
            return (Criteria) this;
        }

        public Criteria andVatIn(List<BigDecimal> values) {
            addCriterion("vat in", values, "vat");
            return (Criteria) this;
        }

        public Criteria andVatNotIn(List<BigDecimal> values) {
            addCriterion("vat not in", values, "vat");
            return (Criteria) this;
        }

        public Criteria andVatBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vat between", value1, value2, "vat");
            return (Criteria) this;
        }

        public Criteria andVatNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("vat not between", value1, value2, "vat");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameIsNull() {
            addCriterion("collectionusername is null");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameIsNotNull() {
            addCriterion("collectionusername is not null");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameEqualTo(String value) {
            addCriterion("collectionusername =", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameNotEqualTo(String value) {
            addCriterion("collectionusername <>", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameGreaterThan(String value) {
            addCriterion("collectionusername >", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameGreaterThanOrEqualTo(String value) {
            addCriterion("collectionusername >=", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameLessThan(String value) {
            addCriterion("collectionusername <", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameLessThanOrEqualTo(String value) {
            addCriterion("collectionusername <=", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameLike(String value) {
            addCriterion("collectionusername like", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameNotLike(String value) {
            addCriterion("collectionusername not like", value, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameIn(List<String> values) {
            addCriterion("collectionusername in", values, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameNotIn(List<String> values) {
            addCriterion("collectionusername not in", values, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameBetween(String value1, String value2) {
            addCriterion("collectionusername between", value1, value2, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusernameNotBetween(String value1, String value2) {
            addCriterion("collectionusername not between", value1, value2, "collectionusername");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneIsNull() {
            addCriterion("collectionusertelephone is null");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneIsNotNull() {
            addCriterion("collectionusertelephone is not null");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneEqualTo(String value) {
            addCriterion("collectionusertelephone =", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneNotEqualTo(String value) {
            addCriterion("collectionusertelephone <>", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneGreaterThan(String value) {
            addCriterion("collectionusertelephone >", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("collectionusertelephone >=", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneLessThan(String value) {
            addCriterion("collectionusertelephone <", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneLessThanOrEqualTo(String value) {
            addCriterion("collectionusertelephone <=", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneLike(String value) {
            addCriterion("collectionusertelephone like", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneNotLike(String value) {
            addCriterion("collectionusertelephone not like", value, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneIn(List<String> values) {
            addCriterion("collectionusertelephone in", values, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneNotIn(List<String> values) {
            addCriterion("collectionusertelephone not in", values, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneBetween(String value1, String value2) {
            addCriterion("collectionusertelephone between", value1, value2, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionusertelephoneNotBetween(String value1, String value2) {
            addCriterion("collectionusertelephone not between", value1, value2, "collectionusertelephone");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressIsNull() {
            addCriterion("collectionuseraddress is null");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressIsNotNull() {
            addCriterion("collectionuseraddress is not null");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressEqualTo(String value) {
            addCriterion("collectionuseraddress =", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressNotEqualTo(String value) {
            addCriterion("collectionuseraddress <>", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressGreaterThan(String value) {
            addCriterion("collectionuseraddress >", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressGreaterThanOrEqualTo(String value) {
            addCriterion("collectionuseraddress >=", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressLessThan(String value) {
            addCriterion("collectionuseraddress <", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressLessThanOrEqualTo(String value) {
            addCriterion("collectionuseraddress <=", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressLike(String value) {
            addCriterion("collectionuseraddress like", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressNotLike(String value) {
            addCriterion("collectionuseraddress not like", value, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressIn(List<String> values) {
            addCriterion("collectionuseraddress in", values, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressNotIn(List<String> values) {
            addCriterion("collectionuseraddress not in", values, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressBetween(String value1, String value2) {
            addCriterion("collectionuseraddress between", value1, value2, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andCollectionuseraddressNotBetween(String value1, String value2) {
            addCriterion("collectionuseraddress not between", value1, value2, "collectionuseraddress");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNull() {
            addCriterion("orderid is null");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNotNull() {
            addCriterion("orderid is not null");
            return (Criteria) this;
        }

        public Criteria andOrderidEqualTo(String value) {
            addCriterion("orderid =", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotEqualTo(String value) {
            addCriterion("orderid <>", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThan(String value) {
            addCriterion("orderid >", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThanOrEqualTo(String value) {
            addCriterion("orderid >=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThan(String value) {
            addCriterion("orderid <", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThanOrEqualTo(String value) {
            addCriterion("orderid <=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLike(String value) {
            addCriterion("orderid like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotLike(String value) {
            addCriterion("orderid not like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidIn(List<String> values) {
            addCriterion("orderid in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotIn(List<String> values) {
            addCriterion("orderid not in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidBetween(String value1, String value2) {
            addCriterion("orderid between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotBetween(String value1, String value2) {
            addCriterion("orderid not between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andSendusercountryIsNull() {
            addCriterion("sendusercountry is null");
            return (Criteria) this;
        }

        public Criteria andSendusercountryIsNotNull() {
            addCriterion("sendusercountry is not null");
            return (Criteria) this;
        }

        public Criteria andSendusercountryEqualTo(String value) {
            addCriterion("sendusercountry =", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryNotEqualTo(String value) {
            addCriterion("sendusercountry <>", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryGreaterThan(String value) {
            addCriterion("sendusercountry >", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryGreaterThanOrEqualTo(String value) {
            addCriterion("sendusercountry >=", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryLessThan(String value) {
            addCriterion("sendusercountry <", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryLessThanOrEqualTo(String value) {
            addCriterion("sendusercountry <=", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryLike(String value) {
            addCriterion("sendusercountry like", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryNotLike(String value) {
            addCriterion("sendusercountry not like", value, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryIn(List<String> values) {
            addCriterion("sendusercountry in", values, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryNotIn(List<String> values) {
            addCriterion("sendusercountry not in", values, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryBetween(String value1, String value2) {
            addCriterion("sendusercountry between", value1, value2, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusercountryNotBetween(String value1, String value2) {
            addCriterion("sendusercountry not between", value1, value2, "sendusercountry");
            return (Criteria) this;
        }

        public Criteria andSendusernameIsNull() {
            addCriterion("sendusername is null");
            return (Criteria) this;
        }

        public Criteria andSendusernameIsNotNull() {
            addCriterion("sendusername is not null");
            return (Criteria) this;
        }

        public Criteria andSendusernameEqualTo(String value) {
            addCriterion("sendusername =", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameNotEqualTo(String value) {
            addCriterion("sendusername <>", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameGreaterThan(String value) {
            addCriterion("sendusername >", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameGreaterThanOrEqualTo(String value) {
            addCriterion("sendusername >=", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameLessThan(String value) {
            addCriterion("sendusername <", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameLessThanOrEqualTo(String value) {
            addCriterion("sendusername <=", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameLike(String value) {
            addCriterion("sendusername like", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameNotLike(String value) {
            addCriterion("sendusername not like", value, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameIn(List<String> values) {
            addCriterion("sendusername in", values, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameNotIn(List<String> values) {
            addCriterion("sendusername not in", values, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameBetween(String value1, String value2) {
            addCriterion("sendusername between", value1, value2, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSendusernameNotBetween(String value1, String value2) {
            addCriterion("sendusername not between", value1, value2, "sendusername");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressIsNull() {
            addCriterion("senduseraddress is null");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressIsNotNull() {
            addCriterion("senduseraddress is not null");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressEqualTo(String value) {
            addCriterion("senduseraddress =", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressNotEqualTo(String value) {
            addCriterion("senduseraddress <>", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressGreaterThan(String value) {
            addCriterion("senduseraddress >", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressGreaterThanOrEqualTo(String value) {
            addCriterion("senduseraddress >=", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressLessThan(String value) {
            addCriterion("senduseraddress <", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressLessThanOrEqualTo(String value) {
            addCriterion("senduseraddress <=", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressLike(String value) {
            addCriterion("senduseraddress like", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressNotLike(String value) {
            addCriterion("senduseraddress not like", value, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressIn(List<String> values) {
            addCriterion("senduseraddress in", values, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressNotIn(List<String> values) {
            addCriterion("senduseraddress not in", values, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressBetween(String value1, String value2) {
            addCriterion("senduseraddress between", value1, value2, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSenduseraddressNotBetween(String value1, String value2) {
            addCriterion("senduseraddress not between", value1, value2, "senduseraddress");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneIsNull() {
            addCriterion("sendusertelephone is null");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneIsNotNull() {
            addCriterion("sendusertelephone is not null");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneEqualTo(String value) {
            addCriterion("sendusertelephone =", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneNotEqualTo(String value) {
            addCriterion("sendusertelephone <>", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneGreaterThan(String value) {
            addCriterion("sendusertelephone >", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("sendusertelephone >=", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneLessThan(String value) {
            addCriterion("sendusertelephone <", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneLessThanOrEqualTo(String value) {
            addCriterion("sendusertelephone <=", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneLike(String value) {
            addCriterion("sendusertelephone like", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneNotLike(String value) {
            addCriterion("sendusertelephone not like", value, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneIn(List<String> values) {
            addCriterion("sendusertelephone in", values, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneNotIn(List<String> values) {
            addCriterion("sendusertelephone not in", values, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneBetween(String value1, String value2) {
            addCriterion("sendusertelephone between", value1, value2, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andSendusertelephoneNotBetween(String value1, String value2) {
            addCriterion("sendusertelephone not between", value1, value2, "sendusertelephone");
            return (Criteria) this;
        }

        public Criteria andIdtpeIsNull() {
            addCriterion("idtpe is null");
            return (Criteria) this;
        }

        public Criteria andIdtpeIsNotNull() {
            addCriterion("idtpe is not null");
            return (Criteria) this;
        }

        public Criteria andIdtpeEqualTo(String value) {
            addCriterion("idtpe =", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeNotEqualTo(String value) {
            addCriterion("idtpe <>", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeGreaterThan(String value) {
            addCriterion("idtpe >", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeGreaterThanOrEqualTo(String value) {
            addCriterion("idtpe >=", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeLessThan(String value) {
            addCriterion("idtpe <", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeLessThanOrEqualTo(String value) {
            addCriterion("idtpe <=", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeLike(String value) {
            addCriterion("idtpe like", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeNotLike(String value) {
            addCriterion("idtpe not like", value, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeIn(List<String> values) {
            addCriterion("idtpe in", values, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeNotIn(List<String> values) {
            addCriterion("idtpe not in", values, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeBetween(String value1, String value2) {
            addCriterion("idtpe between", value1, value2, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIdtpeNotBetween(String value1, String value2) {
            addCriterion("idtpe not between", value1, value2, "idtpe");
            return (Criteria) this;
        }

        public Criteria andIetypeIsNull() {
            addCriterion("ietype is null");
            return (Criteria) this;
        }

        public Criteria andIetypeIsNotNull() {
            addCriterion("ietype is not null");
            return (Criteria) this;
        }

        public Criteria andIetypeEqualTo(String value) {
            addCriterion("ietype =", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotEqualTo(String value) {
            addCriterion("ietype <>", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeGreaterThan(String value) {
            addCriterion("ietype >", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeGreaterThanOrEqualTo(String value) {
            addCriterion("ietype >=", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeLessThan(String value) {
            addCriterion("ietype <", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeLessThanOrEqualTo(String value) {
            addCriterion("ietype <=", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeLike(String value) {
            addCriterion("ietype like", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotLike(String value) {
            addCriterion("ietype not like", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeIn(List<String> values) {
            addCriterion("ietype in", values, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotIn(List<String> values) {
            addCriterion("ietype not in", values, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeBetween(String value1, String value2) {
            addCriterion("ietype between", value1, value2, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotBetween(String value1, String value2) {
            addCriterion("ietype not between", value1, value2, "ietype");
            return (Criteria) this;
        }

        public Criteria andModifymarkIsNull() {
            addCriterion("modifymark is null");
            return (Criteria) this;
        }

        public Criteria andModifymarkIsNotNull() {
            addCriterion("modifymark is not null");
            return (Criteria) this;
        }

        public Criteria andModifymarkEqualTo(String value) {
            addCriterion("modifymark =", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotEqualTo(String value) {
            addCriterion("modifymark <>", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkGreaterThan(String value) {
            addCriterion("modifymark >", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkGreaterThanOrEqualTo(String value) {
            addCriterion("modifymark >=", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkLessThan(String value) {
            addCriterion("modifymark <", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkLessThanOrEqualTo(String value) {
            addCriterion("modifymark <=", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkLike(String value) {
            addCriterion("modifymark like", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotLike(String value) {
            addCriterion("modifymark not like", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkIn(List<String> values) {
            addCriterion("modifymark in", values, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotIn(List<String> values) {
            addCriterion("modifymark not in", values, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkBetween(String value1, String value2) {
            addCriterion("modifymark between", value1, value2, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotBetween(String value1, String value2) {
            addCriterion("modifymark not between", value1, value2, "modifymark");
            return (Criteria) this;
        }

        public Criteria andWasterornotIsNull() {
            addCriterion("wasterornot is null");
            return (Criteria) this;
        }

        public Criteria andWasterornotIsNotNull() {
            addCriterion("wasterornot is not null");
            return (Criteria) this;
        }

        public Criteria andWasterornotEqualTo(String value) {
            addCriterion("wasterornot =", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotNotEqualTo(String value) {
            addCriterion("wasterornot <>", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotGreaterThan(String value) {
            addCriterion("wasterornot >", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotGreaterThanOrEqualTo(String value) {
            addCriterion("wasterornot >=", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotLessThan(String value) {
            addCriterion("wasterornot <", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotLessThanOrEqualTo(String value) {
            addCriterion("wasterornot <=", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotLike(String value) {
            addCriterion("wasterornot like", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotNotLike(String value) {
            addCriterion("wasterornot not like", value, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotIn(List<String> values) {
            addCriterion("wasterornot in", values, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotNotIn(List<String> values) {
            addCriterion("wasterornot not in", values, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotBetween(String value1, String value2) {
            addCriterion("wasterornot between", value1, value2, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andWasterornotNotBetween(String value1, String value2) {
            addCriterion("wasterornot not between", value1, value2, "wasterornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotIsNull() {
            addCriterion("botanyornot is null");
            return (Criteria) this;
        }

        public Criteria andBotanyornotIsNotNull() {
            addCriterion("botanyornot is not null");
            return (Criteria) this;
        }

        public Criteria andBotanyornotEqualTo(String value) {
            addCriterion("botanyornot =", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotNotEqualTo(String value) {
            addCriterion("botanyornot <>", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotGreaterThan(String value) {
            addCriterion("botanyornot >", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotGreaterThanOrEqualTo(String value) {
            addCriterion("botanyornot >=", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotLessThan(String value) {
            addCriterion("botanyornot <", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotLessThanOrEqualTo(String value) {
            addCriterion("botanyornot <=", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotLike(String value) {
            addCriterion("botanyornot like", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotNotLike(String value) {
            addCriterion("botanyornot not like", value, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotIn(List<String> values) {
            addCriterion("botanyornot in", values, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotNotIn(List<String> values) {
            addCriterion("botanyornot not in", values, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotBetween(String value1, String value2) {
            addCriterion("botanyornot between", value1, value2, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andBotanyornotNotBetween(String value1, String value2) {
            addCriterion("botanyornot not between", value1, value2, "botanyornot");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseIsNull() {
            addCriterion("taxedenterprise is null");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseIsNotNull() {
            addCriterion("taxedenterprise is not null");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseEqualTo(String value) {
            addCriterion("taxedenterprise =", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseNotEqualTo(String value) {
            addCriterion("taxedenterprise <>", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseGreaterThan(String value) {
            addCriterion("taxedenterprise >", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseGreaterThanOrEqualTo(String value) {
            addCriterion("taxedenterprise >=", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseLessThan(String value) {
            addCriterion("taxedenterprise <", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseLessThanOrEqualTo(String value) {
            addCriterion("taxedenterprise <=", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseLike(String value) {
            addCriterion("taxedenterprise like", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseNotLike(String value) {
            addCriterion("taxedenterprise not like", value, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseIn(List<String> values) {
            addCriterion("taxedenterprise in", values, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseNotIn(List<String> values) {
            addCriterion("taxedenterprise not in", values, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseBetween(String value1, String value2) {
            addCriterion("taxedenterprise between", value1, value2, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andTaxedenterpriseNotBetween(String value1, String value2) {
            addCriterion("taxedenterprise not between", value1, value2, "taxedenterprise");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspIsNull() {
            addCriterion("cbecodeinsp is null");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspIsNotNull() {
            addCriterion("cbecodeinsp is not null");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspEqualTo(String value) {
            addCriterion("cbecodeinsp =", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotEqualTo(String value) {
            addCriterion("cbecodeinsp <>", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspGreaterThan(String value) {
            addCriterion("cbecodeinsp >", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspGreaterThanOrEqualTo(String value) {
            addCriterion("cbecodeinsp >=", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspLessThan(String value) {
            addCriterion("cbecodeinsp <", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspLessThanOrEqualTo(String value) {
            addCriterion("cbecodeinsp <=", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspLike(String value) {
            addCriterion("cbecodeinsp like", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotLike(String value) {
            addCriterion("cbecodeinsp not like", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspIn(List<String> values) {
            addCriterion("cbecodeinsp in", values, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotIn(List<String> values) {
            addCriterion("cbecodeinsp not in", values, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspBetween(String value1, String value2) {
            addCriterion("cbecodeinsp between", value1, value2, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotBetween(String value1, String value2) {
            addCriterion("cbecodeinsp not between", value1, value2, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspIsNull() {
            addCriterion("ecpcodeinsp is null");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspIsNotNull() {
            addCriterion("ecpcodeinsp is not null");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspEqualTo(String value) {
            addCriterion("ecpcodeinsp =", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspNotEqualTo(String value) {
            addCriterion("ecpcodeinsp <>", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspGreaterThan(String value) {
            addCriterion("ecpcodeinsp >", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspGreaterThanOrEqualTo(String value) {
            addCriterion("ecpcodeinsp >=", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspLessThan(String value) {
            addCriterion("ecpcodeinsp <", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspLessThanOrEqualTo(String value) {
            addCriterion("ecpcodeinsp <=", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspLike(String value) {
            addCriterion("ecpcodeinsp like", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspNotLike(String value) {
            addCriterion("ecpcodeinsp not like", value, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspIn(List<String> values) {
            addCriterion("ecpcodeinsp in", values, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspNotIn(List<String> values) {
            addCriterion("ecpcodeinsp not in", values, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspBetween(String value1, String value2) {
            addCriterion("ecpcodeinsp between", value1, value2, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andEcpcodeinspNotBetween(String value1, String value2) {
            addCriterion("ecpcodeinsp not between", value1, value2, "ecpcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspIsNull() {
            addCriterion("trepcodeinsp is null");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspIsNotNull() {
            addCriterion("trepcodeinsp is not null");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspEqualTo(String value) {
            addCriterion("trepcodeinsp =", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspNotEqualTo(String value) {
            addCriterion("trepcodeinsp <>", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspGreaterThan(String value) {
            addCriterion("trepcodeinsp >", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspGreaterThanOrEqualTo(String value) {
            addCriterion("trepcodeinsp >=", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspLessThan(String value) {
            addCriterion("trepcodeinsp <", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspLessThanOrEqualTo(String value) {
            addCriterion("trepcodeinsp <=", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspLike(String value) {
            addCriterion("trepcodeinsp like", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspNotLike(String value) {
            addCriterion("trepcodeinsp not like", value, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspIn(List<String> values) {
            addCriterion("trepcodeinsp in", values, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspNotIn(List<String> values) {
            addCriterion("trepcodeinsp not in", values, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspBetween(String value1, String value2) {
            addCriterion("trepcodeinsp between", value1, value2, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andTrepcodeinspNotBetween(String value1, String value2) {
            addCriterion("trepcodeinsp not between", value1, value2, "trepcodeinsp");
            return (Criteria) this;
        }

        public Criteria andSubmittimeIsNull() {
            addCriterion("submittime is null");
            return (Criteria) this;
        }

        public Criteria andSubmittimeIsNotNull() {
            addCriterion("submittime is not null");
            return (Criteria) this;
        }

        public Criteria andSubmittimeEqualTo(Date value) {
            addCriterionForJDBCTime("submittime =", value, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeNotEqualTo(Date value) {
            addCriterionForJDBCTime("submittime <>", value, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeGreaterThan(Date value) {
            addCriterionForJDBCTime("submittime >", value, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCTime("submittime >=", value, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeLessThan(Date value) {
            addCriterionForJDBCTime("submittime <", value, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCTime("submittime <=", value, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeIn(List<Date> values) {
            addCriterionForJDBCTime("submittime in", values, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeNotIn(List<Date> values) {
            addCriterionForJDBCTime("submittime not in", values, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeBetween(Date value1, Date value2) {
            addCriterionForJDBCTime("submittime between", value1, value2, "submittime");
            return (Criteria) this;
        }

        public Criteria andSubmittimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCTime("submittime not between", value1, value2, "submittime");
            return (Criteria) this;
        }

        public Criteria andTradecompanyIsNull() {
            addCriterion("tradecompany is null");
            return (Criteria) this;
        }

        public Criteria andTradecompanyIsNotNull() {
            addCriterion("tradecompany is not null");
            return (Criteria) this;
        }

        public Criteria andTradecompanyEqualTo(String value) {
            addCriterion("tradecompany =", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyNotEqualTo(String value) {
            addCriterion("tradecompany <>", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyGreaterThan(String value) {
            addCriterion("tradecompany >", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyGreaterThanOrEqualTo(String value) {
            addCriterion("tradecompany >=", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyLessThan(String value) {
            addCriterion("tradecompany <", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyLessThanOrEqualTo(String value) {
            addCriterion("tradecompany <=", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyLike(String value) {
            addCriterion("tradecompany like", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyNotLike(String value) {
            addCriterion("tradecompany not like", value, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyIn(List<String> values) {
            addCriterion("tradecompany in", values, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyNotIn(List<String> values) {
            addCriterion("tradecompany not in", values, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyBetween(String value1, String value2) {
            addCriterion("tradecompany between", value1, value2, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTradecompanyNotBetween(String value1, String value2) {
            addCriterion("tradecompany not between", value1, value2, "tradecompany");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitIsNull() {
            addCriterion("totalfeeunit is null");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitIsNotNull() {
            addCriterion("totalfeeunit is not null");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitEqualTo(String value) {
            addCriterion("totalfeeunit =", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitNotEqualTo(String value) {
            addCriterion("totalfeeunit <>", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitGreaterThan(String value) {
            addCriterion("totalfeeunit >", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitGreaterThanOrEqualTo(String value) {
            addCriterion("totalfeeunit >=", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitLessThan(String value) {
            addCriterion("totalfeeunit <", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitLessThanOrEqualTo(String value) {
            addCriterion("totalfeeunit <=", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitLike(String value) {
            addCriterion("totalfeeunit like", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitNotLike(String value) {
            addCriterion("totalfeeunit not like", value, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitIn(List<String> values) {
            addCriterion("totalfeeunit in", values, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitNotIn(List<String> values) {
            addCriterion("totalfeeunit not in", values, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitBetween(String value1, String value2) {
            addCriterion("totalfeeunit between", value1, value2, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andTotalfeeunitNotBetween(String value1, String value2) {
            addCriterion("totalfeeunit not between", value1, value2, "totalfeeunit");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeIsNull() {
            addCriterion("countofgoodstype is null");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeIsNotNull() {
            addCriterion("countofgoodstype is not null");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeEqualTo(String value) {
            addCriterion("countofgoodstype =", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeNotEqualTo(String value) {
            addCriterion("countofgoodstype <>", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeGreaterThan(String value) {
            addCriterion("countofgoodstype >", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeGreaterThanOrEqualTo(String value) {
            addCriterion("countofgoodstype >=", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeLessThan(String value) {
            addCriterion("countofgoodstype <", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeLessThanOrEqualTo(String value) {
            addCriterion("countofgoodstype <=", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeLike(String value) {
            addCriterion("countofgoodstype like", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeNotLike(String value) {
            addCriterion("countofgoodstype not like", value, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeIn(List<String> values) {
            addCriterion("countofgoodstype in", values, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeNotIn(List<String> values) {
            addCriterion("countofgoodstype not in", values, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeBetween(String value1, String value2) {
            addCriterion("countofgoodstype between", value1, value2, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andCountofgoodstypeNotBetween(String value1, String value2) {
            addCriterion("countofgoodstype not between", value1, value2, "countofgoodstype");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(BigDecimal value) {
            addCriterion("weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(BigDecimal value) {
            addCriterion("weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(BigDecimal value) {
            addCriterion("weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(BigDecimal value) {
            addCriterion("weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<BigDecimal> values) {
            addCriterion("weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<BigDecimal> values) {
            addCriterion("weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightunitIsNull() {
            addCriterion("weightunit is null");
            return (Criteria) this;
        }

        public Criteria andWeightunitIsNotNull() {
            addCriterion("weightunit is not null");
            return (Criteria) this;
        }

        public Criteria andWeightunitEqualTo(String value) {
            addCriterion("weightunit =", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotEqualTo(String value) {
            addCriterion("weightunit <>", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitGreaterThan(String value) {
            addCriterion("weightunit >", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitGreaterThanOrEqualTo(String value) {
            addCriterion("weightunit >=", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitLessThan(String value) {
            addCriterion("weightunit <", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitLessThanOrEqualTo(String value) {
            addCriterion("weightunit <=", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitLike(String value) {
            addCriterion("weightunit like", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotLike(String value) {
            addCriterion("weightunit not like", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitIn(List<String> values) {
            addCriterion("weightunit in", values, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotIn(List<String> values) {
            addCriterion("weightunit not in", values, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitBetween(String value1, String value2) {
            addCriterion("weightunit between", value1, value2, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotBetween(String value1, String value2) {
            addCriterion("weightunit not between", value1, value2, "weightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightIsNull() {
            addCriterion("newweight is null");
            return (Criteria) this;
        }

        public Criteria andNewweightIsNotNull() {
            addCriterion("newweight is not null");
            return (Criteria) this;
        }

        public Criteria andNewweightEqualTo(BigDecimal value) {
            addCriterion("newweight =", value, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightNotEqualTo(BigDecimal value) {
            addCriterion("newweight <>", value, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightGreaterThan(BigDecimal value) {
            addCriterion("newweight >", value, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("newweight >=", value, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightLessThan(BigDecimal value) {
            addCriterion("newweight <", value, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("newweight <=", value, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightIn(List<BigDecimal> values) {
            addCriterion("newweight in", values, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightNotIn(List<BigDecimal> values) {
            addCriterion("newweight not in", values, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("newweight between", value1, value2, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("newweight not between", value1, value2, "newweight");
            return (Criteria) this;
        }

        public Criteria andNewweightunitIsNull() {
            addCriterion("newweightunit is null");
            return (Criteria) this;
        }

        public Criteria andNewweightunitIsNotNull() {
            addCriterion("newweightunit is not null");
            return (Criteria) this;
        }

        public Criteria andNewweightunitEqualTo(String value) {
            addCriterion("newweightunit =", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitNotEqualTo(String value) {
            addCriterion("newweightunit <>", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitGreaterThan(String value) {
            addCriterion("newweightunit >", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitGreaterThanOrEqualTo(String value) {
            addCriterion("newweightunit >=", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitLessThan(String value) {
            addCriterion("newweightunit <", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitLessThanOrEqualTo(String value) {
            addCriterion("newweightunit <=", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitLike(String value) {
            addCriterion("newweightunit like", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitNotLike(String value) {
            addCriterion("newweightunit not like", value, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitIn(List<String> values) {
            addCriterion("newweightunit in", values, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitNotIn(List<String> values) {
            addCriterion("newweightunit not in", values, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitBetween(String value1, String value2) {
            addCriterion("newweightunit between", value1, value2, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andNewweightunitNotBetween(String value1, String value2) {
            addCriterion("newweightunit not between", value1, value2, "newweightunit");
            return (Criteria) this;
        }

        public Criteria andPlatformurlIsNull() {
            addCriterion("platformurl is null");
            return (Criteria) this;
        }

        public Criteria andPlatformurlIsNotNull() {
            addCriterion("platformurl is not null");
            return (Criteria) this;
        }

        public Criteria andPlatformurlEqualTo(String value) {
            addCriterion("platformurl =", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlNotEqualTo(String value) {
            addCriterion("platformurl <>", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlGreaterThan(String value) {
            addCriterion("platformurl >", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlGreaterThanOrEqualTo(String value) {
            addCriterion("platformurl >=", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlLessThan(String value) {
            addCriterion("platformurl <", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlLessThanOrEqualTo(String value) {
            addCriterion("platformurl <=", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlLike(String value) {
            addCriterion("platformurl like", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlNotLike(String value) {
            addCriterion("platformurl not like", value, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlIn(List<String> values) {
            addCriterion("platformurl in", values, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlNotIn(List<String> values) {
            addCriterion("platformurl not in", values, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlBetween(String value1, String value2) {
            addCriterion("platformurl between", value1, value2, "platformurl");
            return (Criteria) this;
        }

        public Criteria andPlatformurlNotBetween(String value1, String value2) {
            addCriterion("platformurl not between", value1, value2, "platformurl");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspIsNull() {
            addCriterion("collusercountryinsp is null");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspIsNotNull() {
            addCriterion("collusercountryinsp is not null");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspEqualTo(String value) {
            addCriterion("collusercountryinsp =", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspNotEqualTo(String value) {
            addCriterion("collusercountryinsp <>", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspGreaterThan(String value) {
            addCriterion("collusercountryinsp >", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspGreaterThanOrEqualTo(String value) {
            addCriterion("collusercountryinsp >=", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspLessThan(String value) {
            addCriterion("collusercountryinsp <", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspLessThanOrEqualTo(String value) {
            addCriterion("collusercountryinsp <=", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspLike(String value) {
            addCriterion("collusercountryinsp like", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspNotLike(String value) {
            addCriterion("collusercountryinsp not like", value, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspIn(List<String> values) {
            addCriterion("collusercountryinsp in", values, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspNotIn(List<String> values) {
            addCriterion("collusercountryinsp not in", values, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspBetween(String value1, String value2) {
            addCriterion("collusercountryinsp between", value1, value2, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andCollusercountryinspNotBetween(String value1, String value2) {
            addCriterion("collusercountryinsp not between", value1, value2, "collusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspIsNull() {
            addCriterion("sendusercountryinsp is null");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspIsNotNull() {
            addCriterion("sendusercountryinsp is not null");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspEqualTo(String value) {
            addCriterion("sendusercountryinsp =", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspNotEqualTo(String value) {
            addCriterion("sendusercountryinsp <>", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspGreaterThan(String value) {
            addCriterion("sendusercountryinsp >", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspGreaterThanOrEqualTo(String value) {
            addCriterion("sendusercountryinsp >=", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspLessThan(String value) {
            addCriterion("sendusercountryinsp <", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspLessThanOrEqualTo(String value) {
            addCriterion("sendusercountryinsp <=", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspLike(String value) {
            addCriterion("sendusercountryinsp like", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspNotLike(String value) {
            addCriterion("sendusercountryinsp not like", value, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspIn(List<String> values) {
            addCriterion("sendusercountryinsp in", values, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspNotIn(List<String> values) {
            addCriterion("sendusercountryinsp not in", values, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspBetween(String value1, String value2) {
            addCriterion("sendusercountryinsp between", value1, value2, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSendusercountryinspNotBetween(String value1, String value2) {
            addCriterion("sendusercountryinsp not between", value1, value2, "sendusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andPaynumberIsNull() {
            addCriterion("paynumber is null");
            return (Criteria) this;
        }

        public Criteria andPaynumberIsNotNull() {
            addCriterion("paynumber is not null");
            return (Criteria) this;
        }

        public Criteria andPaynumberEqualTo(String value) {
            addCriterion("paynumber =", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotEqualTo(String value) {
            addCriterion("paynumber <>", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberGreaterThan(String value) {
            addCriterion("paynumber >", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberGreaterThanOrEqualTo(String value) {
            addCriterion("paynumber >=", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberLessThan(String value) {
            addCriterion("paynumber <", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberLessThanOrEqualTo(String value) {
            addCriterion("paynumber <=", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberLike(String value) {
            addCriterion("paynumber like", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotLike(String value) {
            addCriterion("paynumber not like", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberIn(List<String> values) {
            addCriterion("paynumber in", values, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotIn(List<String> values) {
            addCriterion("paynumber not in", values, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberBetween(String value1, String value2) {
            addCriterion("paynumber between", value1, value2, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotBetween(String value1, String value2) {
            addCriterion("paynumber not between", value1, value2, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeIsNull() {
            addCriterion("payenterprisecode is null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeIsNotNull() {
            addCriterion("payenterprisecode is not null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeEqualTo(String value) {
            addCriterion("payenterprisecode =", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotEqualTo(String value) {
            addCriterion("payenterprisecode <>", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeGreaterThan(String value) {
            addCriterion("payenterprisecode >", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeGreaterThanOrEqualTo(String value) {
            addCriterion("payenterprisecode >=", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeLessThan(String value) {
            addCriterion("payenterprisecode <", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeLessThanOrEqualTo(String value) {
            addCriterion("payenterprisecode <=", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeLike(String value) {
            addCriterion("payenterprisecode like", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotLike(String value) {
            addCriterion("payenterprisecode not like", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeIn(List<String> values) {
            addCriterion("payenterprisecode in", values, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotIn(List<String> values) {
            addCriterion("payenterprisecode not in", values, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeBetween(String value1, String value2) {
            addCriterion("payenterprisecode between", value1, value2, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotBetween(String value1, String value2) {
            addCriterion("payenterprisecode not between", value1, value2, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameIsNull() {
            addCriterion("payenterprisename is null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameIsNotNull() {
            addCriterion("payenterprisename is not null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameEqualTo(String value) {
            addCriterion("payenterprisename =", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotEqualTo(String value) {
            addCriterion("payenterprisename <>", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameGreaterThan(String value) {
            addCriterion("payenterprisename >", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameGreaterThanOrEqualTo(String value) {
            addCriterion("payenterprisename >=", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameLessThan(String value) {
            addCriterion("payenterprisename <", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameLessThanOrEqualTo(String value) {
            addCriterion("payenterprisename <=", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameLike(String value) {
            addCriterion("payenterprisename like", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotLike(String value) {
            addCriterion("payenterprisename not like", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameIn(List<String> values) {
            addCriterion("payenterprisename in", values, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotIn(List<String> values) {
            addCriterion("payenterprisename not in", values, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameBetween(String value1, String value2) {
            addCriterion("payenterprisename between", value1, value2, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotBetween(String value1, String value2) {
            addCriterion("payenterprisename not between", value1, value2, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentIsNull() {
            addCriterion("otherpayment is null");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentIsNotNull() {
            addCriterion("otherpayment is not null");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentEqualTo(BigDecimal value) {
            addCriterion("otherpayment =", value, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentNotEqualTo(BigDecimal value) {
            addCriterion("otherpayment <>", value, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentGreaterThan(BigDecimal value) {
            addCriterion("otherpayment >", value, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("otherpayment >=", value, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentLessThan(BigDecimal value) {
            addCriterion("otherpayment <", value, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentLessThanOrEqualTo(BigDecimal value) {
            addCriterion("otherpayment <=", value, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentIn(List<BigDecimal> values) {
            addCriterion("otherpayment in", values, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentNotIn(List<BigDecimal> values) {
            addCriterion("otherpayment not in", values, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("otherpayment between", value1, value2, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymentNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("otherpayment not between", value1, value2, "otherpayment");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeIsNull() {
            addCriterion("otherpaymenttype is null");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeIsNotNull() {
            addCriterion("otherpaymenttype is not null");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeEqualTo(String value) {
            addCriterion("otherpaymenttype =", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeNotEqualTo(String value) {
            addCriterion("otherpaymenttype <>", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeGreaterThan(String value) {
            addCriterion("otherpaymenttype >", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeGreaterThanOrEqualTo(String value) {
            addCriterion("otherpaymenttype >=", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeLessThan(String value) {
            addCriterion("otherpaymenttype <", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeLessThanOrEqualTo(String value) {
            addCriterion("otherpaymenttype <=", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeLike(String value) {
            addCriterion("otherpaymenttype like", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeNotLike(String value) {
            addCriterion("otherpaymenttype not like", value, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeIn(List<String> values) {
            addCriterion("otherpaymenttype in", values, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeNotIn(List<String> values) {
            addCriterion("otherpaymenttype not in", values, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeBetween(String value1, String value2) {
            addCriterion("otherpaymenttype between", value1, value2, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andOtherpaymenttypeNotBetween(String value1, String value2) {
            addCriterion("otherpaymenttype not between", value1, value2, "otherpaymenttype");
            return (Criteria) this;
        }

        public Criteria andLmsnoIsNull() {
            addCriterion("lmsno is null");
            return (Criteria) this;
        }

        public Criteria andLmsnoIsNotNull() {
            addCriterion("lmsno is not null");
            return (Criteria) this;
        }

        public Criteria andLmsnoEqualTo(String value) {
            addCriterion("lmsno =", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoNotEqualTo(String value) {
            addCriterion("lmsno <>", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoGreaterThan(String value) {
            addCriterion("lmsno >", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoGreaterThanOrEqualTo(String value) {
            addCriterion("lmsno >=", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoLessThan(String value) {
            addCriterion("lmsno <", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoLessThanOrEqualTo(String value) {
            addCriterion("lmsno <=", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoLike(String value) {
            addCriterion("lmsno like", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoNotLike(String value) {
            addCriterion("lmsno not like", value, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoIn(List<String> values) {
            addCriterion("lmsno in", values, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoNotIn(List<String> values) {
            addCriterion("lmsno not in", values, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoBetween(String value1, String value2) {
            addCriterion("lmsno between", value1, value2, "lmsno");
            return (Criteria) this;
        }

        public Criteria andLmsnoNotBetween(String value1, String value2) {
            addCriterion("lmsno not between", value1, value2, "lmsno");
            return (Criteria) this;
        }

        public Criteria andManuainoIsNull() {
            addCriterion("manuaino is null");
            return (Criteria) this;
        }

        public Criteria andManuainoIsNotNull() {
            addCriterion("manuaino is not null");
            return (Criteria) this;
        }

        public Criteria andManuainoEqualTo(String value) {
            addCriterion("manuaino =", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoNotEqualTo(String value) {
            addCriterion("manuaino <>", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoGreaterThan(String value) {
            addCriterion("manuaino >", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoGreaterThanOrEqualTo(String value) {
            addCriterion("manuaino >=", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoLessThan(String value) {
            addCriterion("manuaino <", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoLessThanOrEqualTo(String value) {
            addCriterion("manuaino <=", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoLike(String value) {
            addCriterion("manuaino like", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoNotLike(String value) {
            addCriterion("manuaino not like", value, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoIn(List<String> values) {
            addCriterion("manuaino in", values, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoNotIn(List<String> values) {
            addCriterion("manuaino not in", values, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoBetween(String value1, String value2) {
            addCriterion("manuaino between", value1, value2, "manuaino");
            return (Criteria) this;
        }

        public Criteria andManuainoNotBetween(String value1, String value2) {
            addCriterion("manuaino not between", value1, value2, "manuaino");
            return (Criteria) this;
        }

        public Criteria andLicensenoIsNull() {
            addCriterion("licenseno is null");
            return (Criteria) this;
        }

        public Criteria andLicensenoIsNotNull() {
            addCriterion("licenseno is not null");
            return (Criteria) this;
        }

        public Criteria andLicensenoEqualTo(String value) {
            addCriterion("licenseno =", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotEqualTo(String value) {
            addCriterion("licenseno <>", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoGreaterThan(String value) {
            addCriterion("licenseno >", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoGreaterThanOrEqualTo(String value) {
            addCriterion("licenseno >=", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoLessThan(String value) {
            addCriterion("licenseno <", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoLessThanOrEqualTo(String value) {
            addCriterion("licenseno <=", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoLike(String value) {
            addCriterion("licenseno like", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotLike(String value) {
            addCriterion("licenseno not like", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoIn(List<String> values) {
            addCriterion("licenseno in", values, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotIn(List<String> values) {
            addCriterion("licenseno not in", values, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoBetween(String value1, String value2) {
            addCriterion("licenseno between", value1, value2, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotBetween(String value1, String value2) {
            addCriterion("licenseno not between", value1, value2, "licenseno");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeIsNull() {
            addCriterion("declaretype is null");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeIsNotNull() {
            addCriterion("declaretype is not null");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeEqualTo(String value) {
            addCriterion("declaretype =", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeNotEqualTo(String value) {
            addCriterion("declaretype <>", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeGreaterThan(String value) {
            addCriterion("declaretype >", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeGreaterThanOrEqualTo(String value) {
            addCriterion("declaretype >=", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeLessThan(String value) {
            addCriterion("declaretype <", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeLessThanOrEqualTo(String value) {
            addCriterion("declaretype <=", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeLike(String value) {
            addCriterion("declaretype like", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeNotLike(String value) {
            addCriterion("declaretype not like", value, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeIn(List<String> values) {
            addCriterion("declaretype in", values, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeNotIn(List<String> values) {
            addCriterion("declaretype not in", values, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeBetween(String value1, String value2) {
            addCriterion("declaretype between", value1, value2, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclaretypeNotBetween(String value1, String value2) {
            addCriterion("declaretype not between", value1, value2, "declaretype");
            return (Criteria) this;
        }

        public Criteria andDeclcodeIsNull() {
            addCriterion("declcode is null");
            return (Criteria) this;
        }

        public Criteria andDeclcodeIsNotNull() {
            addCriterion("declcode is not null");
            return (Criteria) this;
        }

        public Criteria andDeclcodeEqualTo(String value) {
            addCriterion("declcode =", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeNotEqualTo(String value) {
            addCriterion("declcode <>", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeGreaterThan(String value) {
            addCriterion("declcode >", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeGreaterThanOrEqualTo(String value) {
            addCriterion("declcode >=", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeLessThan(String value) {
            addCriterion("declcode <", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeLessThanOrEqualTo(String value) {
            addCriterion("declcode <=", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeLike(String value) {
            addCriterion("declcode like", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeNotLike(String value) {
            addCriterion("declcode not like", value, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeIn(List<String> values) {
            addCriterion("declcode in", values, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeNotIn(List<String> values) {
            addCriterion("declcode not in", values, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeBetween(String value1, String value2) {
            addCriterion("declcode between", value1, value2, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclcodeNotBetween(String value1, String value2) {
            addCriterion("declcode not between", value1, value2, "declcode");
            return (Criteria) this;
        }

        public Criteria andDeclnameIsNull() {
            addCriterion("declname is null");
            return (Criteria) this;
        }

        public Criteria andDeclnameIsNotNull() {
            addCriterion("declname is not null");
            return (Criteria) this;
        }

        public Criteria andDeclnameEqualTo(String value) {
            addCriterion("declname =", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameNotEqualTo(String value) {
            addCriterion("declname <>", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameGreaterThan(String value) {
            addCriterion("declname >", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameGreaterThanOrEqualTo(String value) {
            addCriterion("declname >=", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameLessThan(String value) {
            addCriterion("declname <", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameLessThanOrEqualTo(String value) {
            addCriterion("declname <=", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameLike(String value) {
            addCriterion("declname like", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameNotLike(String value) {
            addCriterion("declname not like", value, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameIn(List<String> values) {
            addCriterion("declname in", values, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameNotIn(List<String> values) {
            addCriterion("declname not in", values, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameBetween(String value1, String value2) {
            addCriterion("declname between", value1, value2, "declname");
            return (Criteria) this;
        }

        public Criteria andDeclnameNotBetween(String value1, String value2) {
            addCriterion("declname not between", value1, value2, "declname");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeIsNull() {
            addCriterion("depositorguarantee is null");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeIsNotNull() {
            addCriterion("depositorguarantee is not null");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeEqualTo(String value) {
            addCriterion("depositorguarantee =", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeNotEqualTo(String value) {
            addCriterion("depositorguarantee <>", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeGreaterThan(String value) {
            addCriterion("depositorguarantee >", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeGreaterThanOrEqualTo(String value) {
            addCriterion("depositorguarantee >=", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeLessThan(String value) {
            addCriterion("depositorguarantee <", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeLessThanOrEqualTo(String value) {
            addCriterion("depositorguarantee <=", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeLike(String value) {
            addCriterion("depositorguarantee like", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeNotLike(String value) {
            addCriterion("depositorguarantee not like", value, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeIn(List<String> values) {
            addCriterion("depositorguarantee in", values, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeNotIn(List<String> values) {
            addCriterion("depositorguarantee not in", values, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeBetween(String value1, String value2) {
            addCriterion("depositorguarantee between", value1, value2, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andDepositorguaranteeNotBetween(String value1, String value2) {
            addCriterion("depositorguarantee not between", value1, value2, "depositorguarantee");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoIsNull() {
            addCriterion("guaranteeno is null");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoIsNotNull() {
            addCriterion("guaranteeno is not null");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoEqualTo(String value) {
            addCriterion("guaranteeno =", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoNotEqualTo(String value) {
            addCriterion("guaranteeno <>", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoGreaterThan(String value) {
            addCriterion("guaranteeno >", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoGreaterThanOrEqualTo(String value) {
            addCriterion("guaranteeno >=", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoLessThan(String value) {
            addCriterion("guaranteeno <", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoLessThanOrEqualTo(String value) {
            addCriterion("guaranteeno <=", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoLike(String value) {
            addCriterion("guaranteeno like", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoNotLike(String value) {
            addCriterion("guaranteeno not like", value, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoIn(List<String> values) {
            addCriterion("guaranteeno in", values, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoNotIn(List<String> values) {
            addCriterion("guaranteeno not in", values, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoBetween(String value1, String value2) {
            addCriterion("guaranteeno between", value1, value2, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andGuaranteenoNotBetween(String value1, String value2) {
            addCriterion("guaranteeno not between", value1, value2, "guaranteeno");
            return (Criteria) this;
        }

        public Criteria andCoinIsNull() {
            addCriterion("coin is null");
            return (Criteria) this;
        }

        public Criteria andCoinIsNotNull() {
            addCriterion("coin is not null");
            return (Criteria) this;
        }

        public Criteria andCoinEqualTo(String value) {
            addCriterion("coin =", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinNotEqualTo(String value) {
            addCriterion("coin <>", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinGreaterThan(String value) {
            addCriterion("coin >", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinGreaterThanOrEqualTo(String value) {
            addCriterion("coin >=", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinLessThan(String value) {
            addCriterion("coin <", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinLessThanOrEqualTo(String value) {
            addCriterion("coin <=", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinLike(String value) {
            addCriterion("coin like", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinNotLike(String value) {
            addCriterion("coin not like", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinIn(List<String> values) {
            addCriterion("coin in", values, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinNotIn(List<String> values) {
            addCriterion("coin not in", values, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinBetween(String value1, String value2) {
            addCriterion("coin between", value1, value2, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinNotBetween(String value1, String value2) {
            addCriterion("coin not between", value1, value2, "coin");
            return (Criteria) this;
        }

        public Criteria andChargetypeIsNull() {
            addCriterion("chargetype is null");
            return (Criteria) this;
        }

        public Criteria andChargetypeIsNotNull() {
            addCriterion("chargetype is not null");
            return (Criteria) this;
        }

        public Criteria andChargetypeEqualTo(String value) {
            addCriterion("chargetype =", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeNotEqualTo(String value) {
            addCriterion("chargetype <>", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeGreaterThan(String value) {
            addCriterion("chargetype >", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeGreaterThanOrEqualTo(String value) {
            addCriterion("chargetype >=", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeLessThan(String value) {
            addCriterion("chargetype <", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeLessThanOrEqualTo(String value) {
            addCriterion("chargetype <=", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeLike(String value) {
            addCriterion("chargetype like", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeNotLike(String value) {
            addCriterion("chargetype not like", value, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeIn(List<String> values) {
            addCriterion("chargetype in", values, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeNotIn(List<String> values) {
            addCriterion("chargetype not in", values, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeBetween(String value1, String value2) {
            addCriterion("chargetype between", value1, value2, "chargetype");
            return (Criteria) this;
        }

        public Criteria andChargetypeNotBetween(String value1, String value2) {
            addCriterion("chargetype not between", value1, value2, "chargetype");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4IsNull() {
            addCriterion("extendfieid4 is null");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4IsNotNull() {
            addCriterion("extendfieid4 is not null");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4EqualTo(String value) {
            addCriterion("extendfieid4 =", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4NotEqualTo(String value) {
            addCriterion("extendfieid4 <>", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4GreaterThan(String value) {
            addCriterion("extendfieid4 >", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4GreaterThanOrEqualTo(String value) {
            addCriterion("extendfieid4 >=", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4LessThan(String value) {
            addCriterion("extendfieid4 <", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4LessThanOrEqualTo(String value) {
            addCriterion("extendfieid4 <=", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4Like(String value) {
            addCriterion("extendfieid4 like", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4NotLike(String value) {
            addCriterion("extendfieid4 not like", value, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4In(List<String> values) {
            addCriterion("extendfieid4 in", values, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4NotIn(List<String> values) {
            addCriterion("extendfieid4 not in", values, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4Between(String value1, String value2) {
            addCriterion("extendfieid4 between", value1, value2, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid4NotBetween(String value1, String value2) {
            addCriterion("extendfieid4 not between", value1, value2, "extendfieid4");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5IsNull() {
            addCriterion("extendfieid5 is null");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5IsNotNull() {
            addCriterion("extendfieid5 is not null");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5EqualTo(String value) {
            addCriterion("extendfieid5 =", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5NotEqualTo(String value) {
            addCriterion("extendfieid5 <>", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5GreaterThan(String value) {
            addCriterion("extendfieid5 >", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5GreaterThanOrEqualTo(String value) {
            addCriterion("extendfieid5 >=", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5LessThan(String value) {
            addCriterion("extendfieid5 <", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5LessThanOrEqualTo(String value) {
            addCriterion("extendfieid5 <=", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5Like(String value) {
            addCriterion("extendfieid5 like", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5NotLike(String value) {
            addCriterion("extendfieid5 not like", value, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5In(List<String> values) {
            addCriterion("extendfieid5 in", values, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5NotIn(List<String> values) {
            addCriterion("extendfieid5 not in", values, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5Between(String value1, String value2) {
            addCriterion("extendfieid5 between", value1, value2, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andExtendfieid5NotBetween(String value1, String value2) {
            addCriterion("extendfieid5 not between", value1, value2, "extendfieid5");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNull() {
            addCriterion("addtime is null");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNotNull() {
            addCriterion("addtime is not null");
            return (Criteria) this;
        }

        public Criteria andAddtimeEqualTo(Date value) {
            addCriterionForJDBCTime("addtime =", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotEqualTo(Date value) {
            addCriterionForJDBCTime("addtime <>", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThan(Date value) {
            addCriterionForJDBCTime("addtime >", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCTime("addtime >=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThan(Date value) {
            addCriterionForJDBCTime("addtime <", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCTime("addtime <=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeIn(List<Date> values) {
            addCriterionForJDBCTime("addtime in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotIn(List<Date> values) {
            addCriterionForJDBCTime("addtime not in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeBetween(Date value1, Date value2) {
            addCriterionForJDBCTime("addtime between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCTime("addtime not between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andKeyidIsNull() {
            addCriterion("keyid is null");
            return (Criteria) this;
        }

        public Criteria andKeyidIsNotNull() {
            addCriterion("keyid is not null");
            return (Criteria) this;
        }

        public Criteria andKeyidEqualTo(String value) {
            addCriterion("keyid =", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotEqualTo(String value) {
            addCriterion("keyid <>", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidGreaterThan(String value) {
            addCriterion("keyid >", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidGreaterThanOrEqualTo(String value) {
            addCriterion("keyid >=", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidLessThan(String value) {
            addCriterion("keyid <", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidLessThanOrEqualTo(String value) {
            addCriterion("keyid <=", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidLike(String value) {
            addCriterion("keyid like", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotLike(String value) {
            addCriterion("keyid not like", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidIn(List<String> values) {
            addCriterion("keyid in", values, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotIn(List<String> values) {
            addCriterion("keyid not in", values, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidBetween(String value1, String value2) {
            addCriterion("keyid between", value1, value2, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotBetween(String value1, String value2) {
            addCriterion("keyid not between", value1, value2, "keyid");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNull() {
            addCriterion("orderstatus is null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNotNull() {
            addCriterion("orderstatus is not null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusEqualTo(String value) {
            addCriterion("orderstatus =", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotEqualTo(String value) {
            addCriterion("orderstatus <>", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThan(String value) {
            addCriterion("orderstatus >", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThanOrEqualTo(String value) {
            addCriterion("orderstatus >=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThan(String value) {
            addCriterion("orderstatus <", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThanOrEqualTo(String value) {
            addCriterion("orderstatus <=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLike(String value) {
            addCriterion("orderstatus like", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotLike(String value) {
            addCriterion("orderstatus not like", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIn(List<String> values) {
            addCriterion("orderstatus in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotIn(List<String> values) {
            addCriterion("orderstatus not in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusBetween(String value1, String value2) {
            addCriterion("orderstatus between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotBetween(String value1, String value2) {
            addCriterion("orderstatus not between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidIsNull() {
            addCriterion("goodsbasicid is null");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidIsNotNull() {
            addCriterion("goodsbasicid is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidEqualTo(String value) {
            addCriterion("goodsbasicid =", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotEqualTo(String value) {
            addCriterion("goodsbasicid <>", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidGreaterThan(String value) {
            addCriterion("goodsbasicid >", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidGreaterThanOrEqualTo(String value) {
            addCriterion("goodsbasicid >=", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidLessThan(String value) {
            addCriterion("goodsbasicid <", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidLessThanOrEqualTo(String value) {
            addCriterion("goodsbasicid <=", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidLike(String value) {
            addCriterion("goodsbasicid like", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotLike(String value) {
            addCriterion("goodsbasicid not like", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidIn(List<String> values) {
            addCriterion("goodsbasicid in", values, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotIn(List<String> values) {
            addCriterion("goodsbasicid not in", values, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidBetween(String value1, String value2) {
            addCriterion("goodsbasicid between", value1, value2, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotBetween(String value1, String value2) {
            addCriterion("goodsbasicid not between", value1, value2, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andSendstatusIsNull() {
            addCriterion("sendstatus is null");
            return (Criteria) this;
        }

        public Criteria andSendstatusIsNotNull() {
            addCriterion("sendstatus is not null");
            return (Criteria) this;
        }

        public Criteria andSendstatusEqualTo(String value) {
            addCriterion("sendstatus =", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotEqualTo(String value) {
            addCriterion("sendstatus <>", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusGreaterThan(String value) {
            addCriterion("sendstatus >", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusGreaterThanOrEqualTo(String value) {
            addCriterion("sendstatus >=", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusLessThan(String value) {
            addCriterion("sendstatus <", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusLessThanOrEqualTo(String value) {
            addCriterion("sendstatus <=", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusLike(String value) {
            addCriterion("sendstatus like", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotLike(String value) {
            addCriterion("sendstatus not like", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusIn(List<String> values) {
            addCriterion("sendstatus in", values, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotIn(List<String> values) {
            addCriterion("sendstatus not in", values, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusBetween(String value1, String value2) {
            addCriterion("sendstatus between", value1, value2, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotBetween(String value1, String value2) {
            addCriterion("sendstatus not between", value1, value2, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonIsNull() {
            addCriterion("senderrorreason is null");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonIsNotNull() {
            addCriterion("senderrorreason is not null");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonEqualTo(String value) {
            addCriterion("senderrorreason =", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotEqualTo(String value) {
            addCriterion("senderrorreason <>", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonGreaterThan(String value) {
            addCriterion("senderrorreason >", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonGreaterThanOrEqualTo(String value) {
            addCriterion("senderrorreason >=", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonLessThan(String value) {
            addCriterion("senderrorreason <", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonLessThanOrEqualTo(String value) {
            addCriterion("senderrorreason <=", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonLike(String value) {
            addCriterion("senderrorreason like", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotLike(String value) {
            addCriterion("senderrorreason not like", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonIn(List<String> values) {
            addCriterion("senderrorreason in", values, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotIn(List<String> values) {
            addCriterion("senderrorreason not in", values, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonBetween(String value1, String value2) {
            addCriterion("senderrorreason between", value1, value2, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotBetween(String value1, String value2) {
            addCriterion("senderrorreason not between", value1, value2, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andUploadidIsNull() {
            addCriterion("uploadid is null");
            return (Criteria) this;
        }

        public Criteria andUploadidIsNotNull() {
            addCriterion("uploadid is not null");
            return (Criteria) this;
        }

        public Criteria andUploadidEqualTo(String value) {
            addCriterion("uploadid =", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidNotEqualTo(String value) {
            addCriterion("uploadid <>", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidGreaterThan(String value) {
            addCriterion("uploadid >", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidGreaterThanOrEqualTo(String value) {
            addCriterion("uploadid >=", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidLessThan(String value) {
            addCriterion("uploadid <", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidLessThanOrEqualTo(String value) {
            addCriterion("uploadid <=", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidLike(String value) {
            addCriterion("uploadid like", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidNotLike(String value) {
            addCriterion("uploadid not like", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidIn(List<String> values) {
            addCriterion("uploadid in", values, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidNotIn(List<String> values) {
            addCriterion("uploadid not in", values, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidBetween(String value1, String value2) {
            addCriterion("uploadid between", value1, value2, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidNotBetween(String value1, String value2) {
            addCriterion("uploadid not between", value1, value2, "uploadid");
            return (Criteria) this;
        }

        public Criteria andBatchnumberIsNull() {
            addCriterion("batchnumber is null");
            return (Criteria) this;
        }

        public Criteria andBatchnumberIsNotNull() {
            addCriterion("batchnumber is not null");
            return (Criteria) this;
        }

        public Criteria andBatchnumberEqualTo(String value) {
            addCriterion("batchnumber =", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberNotEqualTo(String value) {
            addCriterion("batchnumber <>", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberGreaterThan(String value) {
            addCriterion("batchnumber >", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberGreaterThanOrEqualTo(String value) {
            addCriterion("batchnumber >=", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberLessThan(String value) {
            addCriterion("batchnumber <", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberLessThanOrEqualTo(String value) {
            addCriterion("batchnumber <=", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberLike(String value) {
            addCriterion("batchnumber like", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberNotLike(String value) {
            addCriterion("batchnumber not like", value, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberIn(List<String> values) {
            addCriterion("batchnumber in", values, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberNotIn(List<String> values) {
            addCriterion("batchnumber not in", values, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberBetween(String value1, String value2) {
            addCriterion("batchnumber between", value1, value2, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andBatchnumberNotBetween(String value1, String value2) {
            addCriterion("batchnumber not between", value1, value2, "batchnumber");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusIsNull() {
            addCriterion("orderreceiptstatus is null");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusIsNotNull() {
            addCriterion("orderreceiptstatus is not null");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusEqualTo(String value) {
            addCriterion("orderreceiptstatus =", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusNotEqualTo(String value) {
            addCriterion("orderreceiptstatus <>", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusGreaterThan(String value) {
            addCriterion("orderreceiptstatus >", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusGreaterThanOrEqualTo(String value) {
            addCriterion("orderreceiptstatus >=", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusLessThan(String value) {
            addCriterion("orderreceiptstatus <", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusLessThanOrEqualTo(String value) {
            addCriterion("orderreceiptstatus <=", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusLike(String value) {
            addCriterion("orderreceiptstatus like", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusNotLike(String value) {
            addCriterion("orderreceiptstatus not like", value, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusIn(List<String> values) {
            addCriterion("orderreceiptstatus in", values, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusNotIn(List<String> values) {
            addCriterion("orderreceiptstatus not in", values, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusBetween(String value1, String value2) {
            addCriterion("orderreceiptstatus between", value1, value2, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderreceiptstatusNotBetween(String value1, String value2) {
            addCriterion("orderreceiptstatus not between", value1, value2, "orderreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusIsNull() {
            addCriterion("waybillreceiptstatus is null");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusIsNotNull() {
            addCriterion("waybillreceiptstatus is not null");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusEqualTo(String value) {
            addCriterion("waybillreceiptstatus =", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusNotEqualTo(String value) {
            addCriterion("waybillreceiptstatus <>", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusGreaterThan(String value) {
            addCriterion("waybillreceiptstatus >", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusGreaterThanOrEqualTo(String value) {
            addCriterion("waybillreceiptstatus >=", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusLessThan(String value) {
            addCriterion("waybillreceiptstatus <", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusLessThanOrEqualTo(String value) {
            addCriterion("waybillreceiptstatus <=", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusLike(String value) {
            addCriterion("waybillreceiptstatus like", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusNotLike(String value) {
            addCriterion("waybillreceiptstatus not like", value, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusIn(List<String> values) {
            addCriterion("waybillreceiptstatus in", values, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusNotIn(List<String> values) {
            addCriterion("waybillreceiptstatus not in", values, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusBetween(String value1, String value2) {
            addCriterion("waybillreceiptstatus between", value1, value2, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andWaybillreceiptstatusNotBetween(String value1, String value2) {
            addCriterion("waybillreceiptstatus not between", value1, value2, "waybillreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusIsNull() {
            addCriterion("payreceiptstatus is null");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusIsNotNull() {
            addCriterion("payreceiptstatus is not null");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusEqualTo(String value) {
            addCriterion("payreceiptstatus =", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusNotEqualTo(String value) {
            addCriterion("payreceiptstatus <>", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusGreaterThan(String value) {
            addCriterion("payreceiptstatus >", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusGreaterThanOrEqualTo(String value) {
            addCriterion("payreceiptstatus >=", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusLessThan(String value) {
            addCriterion("payreceiptstatus <", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusLessThanOrEqualTo(String value) {
            addCriterion("payreceiptstatus <=", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusLike(String value) {
            addCriterion("payreceiptstatus like", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusNotLike(String value) {
            addCriterion("payreceiptstatus not like", value, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusIn(List<String> values) {
            addCriterion("payreceiptstatus in", values, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusNotIn(List<String> values) {
            addCriterion("payreceiptstatus not in", values, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusBetween(String value1, String value2) {
            addCriterion("payreceiptstatus between", value1, value2, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andPayreceiptstatusNotBetween(String value1, String value2) {
            addCriterion("payreceiptstatus not between", value1, value2, "payreceiptstatus");
            return (Criteria) this;
        }

        public Criteria andOrderheadidIsNull() {
            addCriterion("orderheadid is null");
            return (Criteria) this;
        }

        public Criteria andOrderheadidIsNotNull() {
            addCriterion("orderheadid is not null");
            return (Criteria) this;
        }

        public Criteria andOrderheadidEqualTo(Integer value) {
            addCriterion("orderheadid =", value, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidNotEqualTo(Integer value) {
            addCriterion("orderheadid <>", value, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidGreaterThan(Integer value) {
            addCriterion("orderheadid >", value, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderheadid >=", value, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidLessThan(Integer value) {
            addCriterion("orderheadid <", value, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidLessThanOrEqualTo(Integer value) {
            addCriterion("orderheadid <=", value, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidIn(List<Integer> values) {
            addCriterion("orderheadid in", values, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidNotIn(List<Integer> values) {
            addCriterion("orderheadid not in", values, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidBetween(Integer value1, Integer value2) {
            addCriterion("orderheadid between", value1, value2, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andOrderheadidNotBetween(Integer value1, Integer value2) {
            addCriterion("orderheadid not between", value1, value2, "orderheadid");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3IsNull() {
            addCriterion("extendfieid3 is null");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3IsNotNull() {
            addCriterion("extendfieid3 is not null");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3EqualTo(String value) {
            addCriterion("extendfieid3 =", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3NotEqualTo(String value) {
            addCriterion("extendfieid3 <>", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3GreaterThan(String value) {
            addCriterion("extendfieid3 >", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3GreaterThanOrEqualTo(String value) {
            addCriterion("extendfieid3 >=", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3LessThan(String value) {
            addCriterion("extendfieid3 <", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3LessThanOrEqualTo(String value) {
            addCriterion("extendfieid3 <=", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3Like(String value) {
            addCriterion("extendfieid3 like", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3NotLike(String value) {
            addCriterion("extendfieid3 not like", value, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3In(List<String> values) {
            addCriterion("extendfieid3 in", values, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3NotIn(List<String> values) {
            addCriterion("extendfieid3 not in", values, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3Between(String value1, String value2) {
            addCriterion("extendfieid3 between", value1, value2, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andExtendfieid3NotBetween(String value1, String value2) {
            addCriterion("extendfieid3 not between", value1, value2, "extendfieid3");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeIsNull() {
            addCriterion("inspdeclarecode is null");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeIsNotNull() {
            addCriterion("inspdeclarecode is not null");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeEqualTo(String value) {
            addCriterion("inspdeclarecode =", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeNotEqualTo(String value) {
            addCriterion("inspdeclarecode <>", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeGreaterThan(String value) {
            addCriterion("inspdeclarecode >", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeGreaterThanOrEqualTo(String value) {
            addCriterion("inspdeclarecode >=", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeLessThan(String value) {
            addCriterion("inspdeclarecode <", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeLessThanOrEqualTo(String value) {
            addCriterion("inspdeclarecode <=", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeLike(String value) {
            addCriterion("inspdeclarecode like", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeNotLike(String value) {
            addCriterion("inspdeclarecode not like", value, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeIn(List<String> values) {
            addCriterion("inspdeclarecode in", values, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeNotIn(List<String> values) {
            addCriterion("inspdeclarecode not in", values, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeBetween(String value1, String value2) {
            addCriterion("inspdeclarecode between", value1, value2, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andInspdeclarecodeNotBetween(String value1, String value2) {
            addCriterion("inspdeclarecode not between", value1, value2, "inspdeclarecode");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspIsNull() {
            addCriterion("senderusercountryinsp is null");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspIsNotNull() {
            addCriterion("senderusercountryinsp is not null");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspEqualTo(String value) {
            addCriterion("senderusercountryinsp =", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspNotEqualTo(String value) {
            addCriterion("senderusercountryinsp <>", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspGreaterThan(String value) {
            addCriterion("senderusercountryinsp >", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspGreaterThanOrEqualTo(String value) {
            addCriterion("senderusercountryinsp >=", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspLessThan(String value) {
            addCriterion("senderusercountryinsp <", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspLessThanOrEqualTo(String value) {
            addCriterion("senderusercountryinsp <=", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspLike(String value) {
            addCriterion("senderusercountryinsp like", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspNotLike(String value) {
            addCriterion("senderusercountryinsp not like", value, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspIn(List<String> values) {
            addCriterion("senderusercountryinsp in", values, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspNotIn(List<String> values) {
            addCriterion("senderusercountryinsp not in", values, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspBetween(String value1, String value2) {
            addCriterion("senderusercountryinsp between", value1, value2, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andSenderusercountryinspNotBetween(String value1, String value2) {
            addCriterion("senderusercountryinsp not between", value1, value2, "senderusercountryinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspIsNull() {
            addCriterion("wlqycodeinsp is null");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspIsNotNull() {
            addCriterion("wlqycodeinsp is not null");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspEqualTo(String value) {
            addCriterion("wlqycodeinsp =", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspNotEqualTo(String value) {
            addCriterion("wlqycodeinsp <>", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspGreaterThan(String value) {
            addCriterion("wlqycodeinsp >", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspGreaterThanOrEqualTo(String value) {
            addCriterion("wlqycodeinsp >=", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspLessThan(String value) {
            addCriterion("wlqycodeinsp <", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspLessThanOrEqualTo(String value) {
            addCriterion("wlqycodeinsp <=", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspLike(String value) {
            addCriterion("wlqycodeinsp like", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspNotLike(String value) {
            addCriterion("wlqycodeinsp not like", value, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspIn(List<String> values) {
            addCriterion("wlqycodeinsp in", values, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspNotIn(List<String> values) {
            addCriterion("wlqycodeinsp not in", values, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspBetween(String value1, String value2) {
            addCriterion("wlqycodeinsp between", value1, value2, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andWlqycodeinspNotBetween(String value1, String value2) {
            addCriterion("wlqycodeinsp not between", value1, value2, "wlqycodeinsp");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameIsNull() {
            addCriterion("deliverenterprisename is null");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameIsNotNull() {
            addCriterion("deliverenterprisename is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameEqualTo(String value) {
            addCriterion("deliverenterprisename =", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameNotEqualTo(String value) {
            addCriterion("deliverenterprisename <>", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameGreaterThan(String value) {
            addCriterion("deliverenterprisename >", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameGreaterThanOrEqualTo(String value) {
            addCriterion("deliverenterprisename >=", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameLessThan(String value) {
            addCriterion("deliverenterprisename <", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameLessThanOrEqualTo(String value) {
            addCriterion("deliverenterprisename <=", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameLike(String value) {
            addCriterion("deliverenterprisename like", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameNotLike(String value) {
            addCriterion("deliverenterprisename not like", value, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameIn(List<String> values) {
            addCriterion("deliverenterprisename in", values, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameNotIn(List<String> values) {
            addCriterion("deliverenterprisename not in", values, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameBetween(String value1, String value2) {
            addCriterion("deliverenterprisename between", value1, value2, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDeliverenterprisenameNotBetween(String value1, String value2) {
            addCriterion("deliverenterprisename not between", value1, value2, "deliverenterprisename");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(BigDecimal value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(BigDecimal value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(BigDecimal value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(BigDecimal value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<BigDecimal> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<BigDecimal> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andFreightIsNull() {
            addCriterion("freight is null");
            return (Criteria) this;
        }

        public Criteria andFreightIsNotNull() {
            addCriterion("freight is not null");
            return (Criteria) this;
        }

        public Criteria andFreightEqualTo(BigDecimal value) {
            addCriterion("freight =", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotEqualTo(BigDecimal value) {
            addCriterion("freight <>", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThan(BigDecimal value) {
            addCriterion("freight >", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("freight >=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThan(BigDecimal value) {
            addCriterion("freight <", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("freight <=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightIn(List<BigDecimal> values) {
            addCriterion("freight in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotIn(List<BigDecimal> values) {
            addCriterion("freight not in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("freight between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("freight not between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andIeflagIsNull() {
            addCriterion("ieflag is null");
            return (Criteria) this;
        }

        public Criteria andIeflagIsNotNull() {
            addCriterion("ieflag is not null");
            return (Criteria) this;
        }

        public Criteria andIeflagEqualTo(String value) {
            addCriterion("ieflag =", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagNotEqualTo(String value) {
            addCriterion("ieflag <>", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagGreaterThan(String value) {
            addCriterion("ieflag >", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagGreaterThanOrEqualTo(String value) {
            addCriterion("ieflag >=", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagLessThan(String value) {
            addCriterion("ieflag <", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagLessThanOrEqualTo(String value) {
            addCriterion("ieflag <=", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagLike(String value) {
            addCriterion("ieflag like", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagNotLike(String value) {
            addCriterion("ieflag not like", value, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagIn(List<String> values) {
            addCriterion("ieflag in", values, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagNotIn(List<String> values) {
            addCriterion("ieflag not in", values, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagBetween(String value1, String value2) {
            addCriterion("ieflag between", value1, value2, "ieflag");
            return (Criteria) this;
        }

        public Criteria andIeflagNotBetween(String value1, String value2) {
            addCriterion("ieflag not between", value1, value2, "ieflag");
            return (Criteria) this;
        }

        public Criteria andCoinInspIsNull() {
            addCriterion("coin_insp is null");
            return (Criteria) this;
        }

        public Criteria andCoinInspIsNotNull() {
            addCriterion("coin_insp is not null");
            return (Criteria) this;
        }

        public Criteria andCoinInspEqualTo(String value) {
            addCriterion("coin_insp =", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspNotEqualTo(String value) {
            addCriterion("coin_insp <>", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspGreaterThan(String value) {
            addCriterion("coin_insp >", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspGreaterThanOrEqualTo(String value) {
            addCriterion("coin_insp >=", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspLessThan(String value) {
            addCriterion("coin_insp <", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspLessThanOrEqualTo(String value) {
            addCriterion("coin_insp <=", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspLike(String value) {
            addCriterion("coin_insp like", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspNotLike(String value) {
            addCriterion("coin_insp not like", value, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspIn(List<String> values) {
            addCriterion("coin_insp in", values, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspNotIn(List<String> values) {
            addCriterion("coin_insp not in", values, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspBetween(String value1, String value2) {
            addCriterion("coin_insp between", value1, value2, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCoinInspNotBetween(String value1, String value2) {
            addCriterion("coin_insp not between", value1, value2, "coinInsp");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusIsNull() {
            addCriterion("collection_country_cus is null");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusIsNotNull() {
            addCriterion("collection_country_cus is not null");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusEqualTo(String value) {
            addCriterion("collection_country_cus =", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusNotEqualTo(String value) {
            addCriterion("collection_country_cus <>", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusGreaterThan(String value) {
            addCriterion("collection_country_cus >", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusGreaterThanOrEqualTo(String value) {
            addCriterion("collection_country_cus >=", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusLessThan(String value) {
            addCriterion("collection_country_cus <", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusLessThanOrEqualTo(String value) {
            addCriterion("collection_country_cus <=", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusLike(String value) {
            addCriterion("collection_country_cus like", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusNotLike(String value) {
            addCriterion("collection_country_cus not like", value, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusIn(List<String> values) {
            addCriterion("collection_country_cus in", values, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusNotIn(List<String> values) {
            addCriterion("collection_country_cus not in", values, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusBetween(String value1, String value2) {
            addCriterion("collection_country_cus between", value1, value2, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCollectionCountryCusNotBetween(String value1, String value2) {
            addCriterion("collection_country_cus not between", value1, value2, "collectionCountryCus");
            return (Criteria) this;
        }

        public Criteria andCustomeridIsNull() {
            addCriterion("customerid is null");
            return (Criteria) this;
        }

        public Criteria andCustomeridIsNotNull() {
            addCriterion("customerid is not null");
            return (Criteria) this;
        }

        public Criteria andCustomeridEqualTo(Integer value) {
            addCriterion("customerid =", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotEqualTo(Integer value) {
            addCriterion("customerid <>", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridGreaterThan(Integer value) {
            addCriterion("customerid >", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("customerid >=", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLessThan(Integer value) {
            addCriterion("customerid <", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLessThanOrEqualTo(Integer value) {
            addCriterion("customerid <=", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridIn(List<Integer> values) {
            addCriterion("customerid in", values, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotIn(List<Integer> values) {
            addCriterion("customerid not in", values, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridBetween(Integer value1, Integer value2) {
            addCriterion("customerid between", value1, value2, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotBetween(Integer value1, Integer value2) {
            addCriterion("customerid not between", value1, value2, "customerid");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameIsNull() {
            addCriterion("shelfgoodsname is null");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameIsNotNull() {
            addCriterion("shelfgoodsname is not null");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameEqualTo(String value) {
            addCriterion("shelfgoodsname =", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameNotEqualTo(String value) {
            addCriterion("shelfgoodsname <>", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameGreaterThan(String value) {
            addCriterion("shelfgoodsname >", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameGreaterThanOrEqualTo(String value) {
            addCriterion("shelfgoodsname >=", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameLessThan(String value) {
            addCriterion("shelfgoodsname <", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameLessThanOrEqualTo(String value) {
            addCriterion("shelfgoodsname <=", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameLike(String value) {
            addCriterion("shelfgoodsname like", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameNotLike(String value) {
            addCriterion("shelfgoodsname not like", value, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameIn(List<String> values) {
            addCriterion("shelfgoodsname in", values, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameNotIn(List<String> values) {
            addCriterion("shelfgoodsname not in", values, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameBetween(String value1, String value2) {
            addCriterion("shelfgoodsname between", value1, value2, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andShelfgoodsnameNotBetween(String value1, String value2) {
            addCriterion("shelfgoodsname not between", value1, value2, "shelfgoodsname");
            return (Criteria) this;
        }

        public Criteria andGoodnameIsNull() {
            addCriterion("goodname is null");
            return (Criteria) this;
        }

        public Criteria andGoodnameIsNotNull() {
            addCriterion("goodname is not null");
            return (Criteria) this;
        }

        public Criteria andGoodnameEqualTo(String value) {
            addCriterion("goodname =", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameNotEqualTo(String value) {
            addCriterion("goodname <>", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameGreaterThan(String value) {
            addCriterion("goodname >", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameGreaterThanOrEqualTo(String value) {
            addCriterion("goodname >=", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameLessThan(String value) {
            addCriterion("goodname <", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameLessThanOrEqualTo(String value) {
            addCriterion("goodname <=", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameLike(String value) {
            addCriterion("goodname like", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameNotLike(String value) {
            addCriterion("goodname not like", value, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameIn(List<String> values) {
            addCriterion("goodname in", values, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameNotIn(List<String> values) {
            addCriterion("goodname not in", values, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameBetween(String value1, String value2) {
            addCriterion("goodname between", value1, value2, "goodname");
            return (Criteria) this;
        }

        public Criteria andGoodnameNotBetween(String value1, String value2) {
            addCriterion("goodname not between", value1, value2, "goodname");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnit1IsNull() {
            addCriterion("unit1 is null");
            return (Criteria) this;
        }

        public Criteria andUnit1IsNotNull() {
            addCriterion("unit1 is not null");
            return (Criteria) this;
        }

        public Criteria andUnit1EqualTo(String value) {
            addCriterion("unit1 =", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1NotEqualTo(String value) {
            addCriterion("unit1 <>", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1GreaterThan(String value) {
            addCriterion("unit1 >", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1GreaterThanOrEqualTo(String value) {
            addCriterion("unit1 >=", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1LessThan(String value) {
            addCriterion("unit1 <", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1LessThanOrEqualTo(String value) {
            addCriterion("unit1 <=", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1Like(String value) {
            addCriterion("unit1 like", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1NotLike(String value) {
            addCriterion("unit1 not like", value, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1In(List<String> values) {
            addCriterion("unit1 in", values, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1NotIn(List<String> values) {
            addCriterion("unit1 not in", values, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1Between(String value1, String value2) {
            addCriterion("unit1 between", value1, value2, "unit1");
            return (Criteria) this;
        }

        public Criteria andUnit1NotBetween(String value1, String value2) {
            addCriterion("unit1 not between", value1, value2, "unit1");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(Integer value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(Integer value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(Integer value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(Integer value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(Integer value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(Integer value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<Integer> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<Integer> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(Integer value1, Integer value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(Integer value1, Integer value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmount1IsNull() {
            addCriterion("amount1 is null");
            return (Criteria) this;
        }

        public Criteria andAmount1IsNotNull() {
            addCriterion("amount1 is not null");
            return (Criteria) this;
        }

        public Criteria andAmount1EqualTo(BigDecimal value) {
            addCriterion("amount1 =", value, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1NotEqualTo(BigDecimal value) {
            addCriterion("amount1 <>", value, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1GreaterThan(BigDecimal value) {
            addCriterion("amount1 >", value, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("amount1 >=", value, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1LessThan(BigDecimal value) {
            addCriterion("amount1 <", value, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1LessThanOrEqualTo(BigDecimal value) {
            addCriterion("amount1 <=", value, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1In(List<BigDecimal> values) {
            addCriterion("amount1 in", values, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1NotIn(List<BigDecimal> values) {
            addCriterion("amount1 not in", values, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount1 between", value1, value2, "amount1");
            return (Criteria) this;
        }

        public Criteria andAmount1NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount1 not between", value1, value2, "amount1");
            return (Criteria) this;
        }

        public Criteria andNetweightIsNull() {
            addCriterion("netweight is null");
            return (Criteria) this;
        }

        public Criteria andNetweightIsNotNull() {
            addCriterion("netweight is not null");
            return (Criteria) this;
        }

        public Criteria andNetweightEqualTo(BigDecimal value) {
            addCriterion("netweight =", value, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightNotEqualTo(BigDecimal value) {
            addCriterion("netweight <>", value, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightGreaterThan(BigDecimal value) {
            addCriterion("netweight >", value, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("netweight >=", value, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightLessThan(BigDecimal value) {
            addCriterion("netweight <", value, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("netweight <=", value, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightIn(List<BigDecimal> values) {
            addCriterion("netweight in", values, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightNotIn(List<BigDecimal> values) {
            addCriterion("netweight not in", values, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("netweight between", value1, value2, "netweight");
            return (Criteria) this;
        }

        public Criteria andNetweightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("netweight not between", value1, value2, "netweight");
            return (Criteria) this;
        }

        public Criteria andSpecificationsIsNull() {
            addCriterion("specifications is null");
            return (Criteria) this;
        }

        public Criteria andSpecificationsIsNotNull() {
            addCriterion("specifications is not null");
            return (Criteria) this;
        }

        public Criteria andSpecificationsEqualTo(String value) {
            addCriterion("specifications =", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsNotEqualTo(String value) {
            addCriterion("specifications <>", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsGreaterThan(String value) {
            addCriterion("specifications >", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsGreaterThanOrEqualTo(String value) {
            addCriterion("specifications >=", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsLessThan(String value) {
            addCriterion("specifications <", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsLessThanOrEqualTo(String value) {
            addCriterion("specifications <=", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsLike(String value) {
            addCriterion("specifications like", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsNotLike(String value) {
            addCriterion("specifications not like", value, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsIn(List<String> values) {
            addCriterion("specifications in", values, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsNotIn(List<String> values) {
            addCriterion("specifications not in", values, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsBetween(String value1, String value2) {
            addCriterion("specifications between", value1, value2, "specifications");
            return (Criteria) this;
        }

        public Criteria andSpecificationsNotBetween(String value1, String value2) {
            addCriterion("specifications not between", value1, value2, "specifications");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNull() {
            addCriterion("barcode is null");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNotNull() {
            addCriterion("barcode is not null");
            return (Criteria) this;
        }

        public Criteria andBarcodeEqualTo(String value) {
            addCriterion("barcode =", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotEqualTo(String value) {
            addCriterion("barcode <>", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThan(String value) {
            addCriterion("barcode >", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThanOrEqualTo(String value) {
            addCriterion("barcode >=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThan(String value) {
            addCriterion("barcode <", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThanOrEqualTo(String value) {
            addCriterion("barcode <=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLike(String value) {
            addCriterion("barcode like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotLike(String value) {
            addCriterion("barcode not like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeIn(List<String> values) {
            addCriterion("barcode in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotIn(List<String> values) {
            addCriterion("barcode not in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeBetween(String value1, String value2) {
            addCriterion("barcode between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotBetween(String value1, String value2) {
            addCriterion("barcode not between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andCoininspIsNull() {
            addCriterion("coininsp is null");
            return (Criteria) this;
        }

        public Criteria andCoininspIsNotNull() {
            addCriterion("coininsp is not null");
            return (Criteria) this;
        }

        public Criteria andCoininspEqualTo(String value) {
            addCriterion("coininsp =", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotEqualTo(String value) {
            addCriterion("coininsp <>", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspGreaterThan(String value) {
            addCriterion("coininsp >", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspGreaterThanOrEqualTo(String value) {
            addCriterion("coininsp >=", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspLessThan(String value) {
            addCriterion("coininsp <", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspLessThanOrEqualTo(String value) {
            addCriterion("coininsp <=", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspLike(String value) {
            addCriterion("coininsp like", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotLike(String value) {
            addCriterion("coininsp not like", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspIn(List<String> values) {
            addCriterion("coininsp in", values, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotIn(List<String> values) {
            addCriterion("coininsp not in", values, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspBetween(String value1, String value2) {
            addCriterion("coininsp between", value1, value2, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotBetween(String value1, String value2) {
            addCriterion("coininsp not between", value1, value2, "coininsp");
            return (Criteria) this;
        }

        public Criteria andGoodpriceIsNull() {
            addCriterion("goodprice is null");
            return (Criteria) this;
        }

        public Criteria andGoodpriceIsNotNull() {
            addCriterion("goodprice is not null");
            return (Criteria) this;
        }

        public Criteria andGoodpriceEqualTo(BigDecimal value) {
            addCriterion("goodprice =", value, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceNotEqualTo(BigDecimal value) {
            addCriterion("goodprice <>", value, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceGreaterThan(BigDecimal value) {
            addCriterion("goodprice >", value, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goodprice >=", value, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceLessThan(BigDecimal value) {
            addCriterion("goodprice <", value, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goodprice <=", value, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceIn(List<BigDecimal> values) {
            addCriterion("goodprice in", values, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceNotIn(List<BigDecimal> values) {
            addCriterion("goodprice not in", values, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goodprice between", value1, value2, "goodprice");
            return (Criteria) this;
        }

        public Criteria andGoodpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goodprice not between", value1, value2, "goodprice");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}